home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / subbatch.sql < prev    next >
Text File  |  2000-05-12  |  1KB  |  51 lines
  1. /* RCSVER $Id: subbatch.sql,v 1.1 1999-03-19 11:36:58-06 evan CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        cashboxcount
  6. * Date:        1/10/1999
  7. * memo:        Evan M. Ghormley    
  8. * Description:    Create the cashboxcount table. 
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE subbatch
  12. (
  13.      subbatch_seq        NUMBER(38) PRIMARY KEY,
  14.      mrc_batch_id        NUMBER(38),
  15.     insert_date        DATE,
  16.     coin_equip_date     VARCHAR2(20),
  17.     coin_equip_audit_number    VARCHAR2(20),
  18.     label_a            NUMBER(38),    
  19.     label_b            VARCHAR2(20),
  20.     label_c            NUMBER(38),
  21.     label_d            VARCHAR2(20),
  22.     equip_op_id        NUMBER(38),
  23.     coin_one        NUMBER(20,2),
  24.     coin_two        NUMBER(20,2),
  25.     coin_three        NUMBER(20,2),
  26.     coin_four        NUMBER(20,2),
  27.     coin_five        NUMBER(20,2),
  28.     coin_six        NUMBER(20,2),
  29.     coin_seven        NUMBER(20,2),
  30.     coin_eight        NUMBER(20,2),
  31.     coin_nine        NUMBER(20,2),
  32.     coin_total_value     NUMBER(20,2),
  33.     currency        NUMBER(20,2),
  34.     checks            NUMBER(20,2),
  35.     misc            NUMBER(20,2),
  36.     bill_one        NUMBER(20,2),
  37.     bill_two        NUMBER(20,2),
  38.     bill_three        NUMBER(20,2),
  39.     bill_four        NUMBER(20,2),
  40.     bill_five        NUMBER(20,2),
  41.     bill_six        NUMBER(20,2),
  42.     bill_seven        NUMBER(20,2),
  43.     bill_eight        NUMBER(20,2),
  44.     bill_nine        NUMBER(20,2),
  45.     declared_balance     NUMBER(20,2),
  46.     receipt_total       NUMBER(20,2),
  47.     grand_total         NUMBER(20,2),
  48.     manual_entry        VARCHAR2(1)
  49. );
  50.  
  51.